Title: SQL W3S (By-BKK) / 119 Hosting
Tags: Obsidian_to_Anki

Q: What is SQL hosting?
A: SQL hosting is when a web server is connected to a database system that uses SQL language to store and retrieve data

Q: Why do you need SQL hosting for your website?
A: To allow your website to store and retrieve data from a database using SQL

Q: True or False: Every web server automatically includes an SQL database
A: False

Q: What should you look for if your site is hosted by an ISP and you want SQL hosting?
A: You should look for SQL hosting plans

Q: Name four common SQL hosting databases
A: MS SQL Server, Oracle, MySQL, and MS Access

Q: Which database software is popular for high-traffic, database-driven websites?
A: MS SQL Server, Oracle, and MySQL

Q: True or False: MS SQL Server is not suitable for high-traffic websites
A: False

Q: Why is MS SQL Server often chosen for database-driven websites with high traffic?
A: It is powerful, robust, and full featured

Q: What are some strengths of Oracle SQL database?
A: Oracle is very powerful, robust, and full featured for high-traffic sites

Q: True or False: MySQL is an expensive database solution
A: False

Q: What makes MySQL a common choice for web sites?
A: It is powerful, robust, full featured, and inexpensive compared to Microsoft and Oracle solutions

Q: When is MS Access a suitable choice for SQL hosting?
A: When a website needs only a simple database

Q: True or False: MS Access is well suited for very high-traffic websites
A: False

Q: Why isn’t MS Access as powerful as the other options?
A: It is not as powerful as MySQL, SQL Server, or Oracle and not suited for very high-traffic websites

Q: Reverse card (answer first): MS SQL Server, Oracle, MySQL, and MS Access are examples of what?
A: They are common SQL hosting databases

Q: Reverse card (answer first): You choose MySQL when you want a robust, full featured, but inexpensive SQL database
A: Why might you choose MySQL over Microsoft or Oracle for hosting?